package com.easybuilder.core.seo.dao;

import com.easybuilder.common.base.dao.BaseDao;
import com.easybuilder.core.seo.entity.SysSeoHistory;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;
import tk.mybatis.mapper.common.ExampleMapper;
import org.springframework.stereotype.Repository;

import java.util.List;


@Repository
public interface SysSeoHistoryDao extends BaseDao<SysSeoHistory>, ExampleMapper<SysSeoHistory> {

    /** 统计总量和新增量 */
    @Select("select count(1) from sys_seo_history union all select count(1) from sys_seo_history where create_time like '${date}%'")
    List<Integer> countSeoHistory(@Param("date") String date);
}